
**********
*Table 2: Pre-crisis trends of malaria incidence rates
**********

*****2003-2013
***Column 1/Row 1 Pacaraima - Non BR 174
clear all
set more off
cap log close
cd ""
use , replace 

keep treat1 treat3
rename treat1 pacaraima

global x "life_expect illit_25 school gini poverty water_sewer  garbage electric female_pop agriculture fish construction mine def rain temp cattle rural"

reg malaria year $x i.munic_code i.year if post== 0 & pacaraima == 1
outreg2 using table2.1.1, replace stats(coef se) asterisk(coeff)

***Column 2/Row 1 Pacaraima - Amazonia Legal 
clear all
set more off
cap log close
cd ""
use, replace 

keep treat1 treat7
rename treat1 pacaraima

global x "life_expect illit_25 school gini poverty water_sewer  garbage electric female_pop agriculture fish construction mine def rain temp cattle rural"

reg malaria year $x i.munic_code i.year if post== 0 & pacaraima == 1
outreg2 using table2.2.1, replace stats(coef se) asterisk(coeff)


***Column 1/Row 2 Boa Vista - Non BR 174
clear all
set more off
cap log close
cd ""
use , replace 

keep treat3 treat4
rename treat4 boa

global x "life_expect illit_25 school gini poverty water_sewer  garbage electric female_pop agriculture fish construction mine def rain temp cattle rural"

reg malaria year $x i.munic_code i.year if post== 0 & boa == 1
outreg2 using table2.1.1, replace stats(coef se) asterisk(coeff)


***Column 1/Row 3 BR 174 - Non BR 174
clear all
set more off
cap log close
cd ""
use , replace 

keep treat2 treat3
rename treat2 BR

global x "life_expect illit_25 school gini poverty water_sewer  garbage electric female_pop agriculture fish construction mine def rain temp cattle rural"

reg malaria year $x i.munic_code i.year if post== 0 & BR == 1, cl(munic_code)
outreg2 using table2.1.3, replace stats(coef se) asterisk(coeff)


***Column 2/Row 3 BR 174 - Amazonia Legal  
clear all
set more off
cap log close
cd ""
use , replace 

keep if treat2 treat7
rename treat2 BR

global x "life_expect illit_25 school gini poverty water_sewer  garbage electric female_pop agriculture fish construction mine def rain temp cattle rural"

reg malaria year $x i.munic_code i.year if post== 0 & BR == 1, cl(munic_code)
outreg2 using table2.2.3, replace stats(coef se) asterisk(coeff)
